<?php ini_set("memory_limit","32M"); ?>
<link href="<?=base_url()?>asset/admin/css/style.css" rel="stylesheet" type="text/css">

<script type="text/javascript">
	function report_pdf(){		      
            var site = "<?php echo site_url()?>";
           /* $.ajax({
                url: site+"/laporan_pembelian/index",
                success: function(response){			
                $("#tab").html(response);
                },
            dataType:"html"  		
            });
            return false;*/
			var periode_awal=document.getElementById('tanggal_awal').value;
			var periode_akhir=document.getElementById('tanggal_akhir').value;
			  location.href = site+"/laporan_buku_kas/report_pdf/"+periode_awal+'/'+periode_akhir;
	}
	
	function report_excel(){
		document.getElementById("rekap_tabel1").value = document.getElementById("div_laporan").innerHTML;
		document.getElementById("myform").submit();
	}
	
	
	function print(){
		/*<form>
		<input type="button" value="Print This Page" onClick="window.print()" />
		</form>*/
	}
	
	
</script>
			<div id="tab-settings" class="tabs-content">
					<button type="button" onclick="report_pdf()"><img src="<?=base_url()?>asset/admin/images/icons/fugue/tick-circle.png" width="16" height="16">REKAP PDF</button>
					<button type="submit" onclick="report_excel()"><img src="<?=base_url()?>asset/admin/images/icons/fugue/tick-circle.png" width="16" height="16">REKAP EXCEL</button>
					
			</div>	
<?php
	$attributes = array('class' => 'formccs', 'id' => 'myform', 'name'=> 'myform');	
	echo form_open('laporan_buku_kas/report_excel', $attributes);
?>	
<div id="div_laporan">
	<input name="rekap_tabel1" id="rekap_tabel1" type="hidden" value="rekap_tabel1" />
	<input name="periode_awal" id="tanggal_awal" type="hidden" value="<?=$periode_awal;?>" />
	<input name="periode_akhir" id="tanggal_akhir" type="hidden" value="<?=$periode_akhir;?>" />
	
	<table class="laporan" width="90%" border="1">
		<tr><td colspan="7"  div align="center"><b>KEMENTRIAN KOMUNIKASI DAN INFORMATIKA</b></td></tr>		<tr><td colspan="7"  div align="center"><b>DIREKTORAT JENDERAL PENYELENGGARAAN POS DAN INFORMATIKA</b></td></tr>
		
		<tr><td colspan="7" div align="center"><b>BALAI PENYEDIA DAN PENGELOLA PEMBIAYAAN TELEKOMUNIKASI DAN INFORMATIKA</b><br/></td></tr>
		<tr><td colspan="7" div align="center"><b>LAPORAN REALISASI ANGGARAN</b></td></tr>
		<tr><td colspan="7" div align="center"><b>Per : <?php echo $this->fungsi->dateindo3('-',$periode_awal) . ' S/D ' .  $this->fungsi->dateindo3('-',$periode_akhir); ?></b></td></tr>		<tr><td colspan="7" div align="center">(Dalam Rupiah)</td></tr>
		<!--<tr><td colspan="10"><b>TANGGAL CETAK : <?php /* echo $this->fungsi->dateindo3('-',date('Y-m-d')) */ ?></b></td></tr>-->
		<tr>
			<th scope="col">KODE</th>			<th scope="col">KEGIATAN/OUTPUT/KOMPONEN/SUBKOMPONEN/AKUN/DETAIL</th>
			<th scope="col">PLAFON</th>
			<th scope="col">REALISASI S/D BULAN LALU</th>			<th scope="col">REALISASI BULAN INI</th>			<th scope="col">JUMLAH REALISASI</th>			<th scope="col">SALDO</th>			
		</tr>			<?			$j=1;			foreach($results->result() as $row)			{					$jumlah_anggaran=0;				$jml_bulan_sekarang=0;				$jml_bulan_lalu=0;				$jml_realisasi=0;				$saldo=0;								$jumlah_anggaran = $row->jumlah_anggaran;				$jml_bulan_sekarang=$row->jml_bulan_sekarang_debet - $row->jml_bulan_sekarang_kredit;				$jml_bulan_lalu = $row->jml_bulan_lalu_debet - $row->jml_bulan_lalu_kredit;				$jml_realisasi = $jml_bulan_sekarang + $jml_bulan_lalu ;								$saldo = $jumlah_anggaran - ($jml_realisasi);		?>						<tr>							<td align="right" valign="middle"><?=$row->akunidgroup;?></td>							<td align="left" valign="middle">								<?php 									echo $row->nakun;																										?>							</td>														<td align="right" valign="middle"><?=convert_rupiah_non_rp($row->jumlah_anggaran);?></td>							<td align="right" valign="middle">								<?php									/*if ($bulan_db==$monthlast){										$row->KREDIT;									}*/																		if ($jml_bulan_lalu!=null)										echo convert_rupiah_non_rp($jml_bulan_lalu);									else										echo '0';								?>							</td>							<td align="right" valign="middle">								<?php									/*if ($bulan_db==$monthnow){										echo $row->KREDIT;									}*/																		if ($jml_bulan_sekarang!=null)										echo convert_rupiah_non_rp($jml_bulan_sekarang);									else										echo '0';								?>							</td>							<td align="right" valign="middle"><?php 																if($jml_realisasi!=0) echo convert_rupiah_non_rp($jml_realisasi); else echo '0'; 																?></td>							<td align="right" valign="middle"><?=convert_rupiah_non_rp($saldo);?></td>																			</tr>		<?php			}		?>			<tr>				<td>&nbsp;</td>				<td></td>				<td colspan="5"></td>			</tr>			<tr>				<td></td>				<td>Jumlah RM</td>				<td></td>				<td></td>				<td></td>				<td></td>				<td></td>			</tr>			<tr>				<td></td>				<td>Jumlah PNBP</td>				<td></td>				<td></td>				<td></td>				<td></td>				<td></td>			</tr>			<tr>				<td></td>				<td>Jumlah TOTAL</td>				<td></td>				<td></td>				<td></td>				<td></td>				<td></td>			</tr>
	</table>
</div>
</form>